County Profile for Franklin - 2017



County Controls Information

Cost Report Counts Population
Total Hospital Count 1 Total Population on July 31, 2017 0
Total Cost Reports Filed in 2017 1 Total Births 0
Total Cost Reports Submitted 0 Total Deaths 0
Total Cost Reports Settled 1 Net Population Natural Change 0
Total Cost Reports Reopened 0 Total International Migration 0
Total Cost Reports Ammended 0 Total Domestic Migration 0
Total Cost Reports Audited 0 Total Residual 0
Net Population Change 0

County Financial Statements - Worksheet G

Balance Sheet Income Statement
Current Assets 14,459,924 Total Charges 166,715,106
Fixed Assets 26,356,778 Contract Allowance 93,323,405
Other Assets 4,851,553 Operating Revenue 73,391,701
Total Assets 45,668,255 Operating Expenses 81,194,828
Current Liabilities 9,763,772 Operating Margin -7,803,127
Long Term Liabilities 18,041,342 Other Income 4,048,394
Total Equity 17,863,141 Other Expense 0
Total Liabilities and Equity 45,668,255 Net Profit or Loss -3,754,733

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $44,292 Revenue per Bed $1,667,993 Revenue per Person $73,391,701
Net Margin per Discharge ($4,709) Net Margin per Bed ($177,344) Net Margin per Person ($7,803,127)
Net Profit per Discharge ($2,266) Net Profit per Bed ($85,335) Net Profit per Person ($3,754,733)
Net Fixed Assets per Discharge $15,906 Net Fixed Assets per Bed $599,018 Net Fixed Assets per Bed $26,356,778
Long Term Debt per Discharge $10,888 Long Term Debt per Bed $410,031 Long Term Debt per Person $18,041,342
Persons per Discharge 0 Persons per Bed 0
Occupancy Rate 39.1 %
Length of Stay 4 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 1,224 Net Fixed Assets 1,268 Population Estimate 1,151
Total Revenue 1,133 Long Term Liabilities 1,072 Total Patient Discharges 1,273
Net Margin 2,767 Total Patient Beds 1,358
Net Profit or Loss 3,003

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 8,075,792 14,744,648 0.5477
31 Intensive Care Unit 644,643 977,850 0.6592
32 Coronary Care Unit 0 0
43 Nursery 1,099,461 1,004,671 1.0943
44 Skilled Nursing Care 0 0
50 Operating Room 6,723,194 18,742,355 0.3587
51 Recovery Room 0 0
52 Labor and Delivery Room 157,362 278,292 0.5655

County General Service Cost - Worksheet A

Lines Description Amount Lines Description Amount
01 Capital Related - Building and Fixtures 3,035,964 13 Nursing Administration 463,549
02,03 Captial Related - Movable Equipment 1,338,160 14 Central Services and Supply 679,176
04 Employee Benefits 7,049,554 15 Pharmacy 363,723
05 Administrative and General 15,152,199 16 Medical Records and Medical Library 916,815
06 Maintenance and Repairs 1,348,561 17 Social Services 174,208
07 Operation of Plant 929,029 18 Other General Service Expense 0
08,09 Laundry, Linen and Housekeeping 1,046,083 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 761,542 20,21,22,23 Education Programs 0
Total General Service Cost Centers 33,258,563

County Profile for Franklin - 2017